Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 5267 |
| Missing cells | 15758 |
| Missing cells (%) | 10.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.4 MiB |
| Average record size in memory | 1.0 KiB |
Variable types
| Categorical | 12 |
|---|---|
| Numeric | 10 |
| Boolean | 5 |
| DateTime | 1 |
BM Unit ID has a high cardinality: 5267 distinct values | High cardinality |
BMU Name has a high cardinality: 5143 distinct values | High cardinality |
Party Name has a high cardinality: 349 distinct values | High cardinality |
Party ID has a high cardinality: 349 distinct values | High cardinality |
NGC BMU Name has a high cardinality: 1817 distinct values | High cardinality |
Trading Unit Name has a high cardinality: 52 distinct values | High cardinality |
TLF is highly overall correlated with GSP Group Id and 3 other fields | High correlation |
GC is highly overall correlated with WDBMCAEC and 4 other fields | High correlation |
DC is highly overall correlated with WDBMCAIC and 2 other fields | High correlation |
WDCALF is highly overall correlated with NWDCALF and 3 other fields | High correlation |
NWDCALF is highly overall correlated with WDCALF and 4 other fields | High correlation |
SECALF is highly overall correlated with WDCALF and 4 other fields | High correlation |
WDBMCAIC is highly overall correlated with DC and 3 other fields | High correlation |
NWDBMCAIC is highly overall correlated with DC and 3 other fields | High correlation |
WDBMCAEC is highly overall correlated with GC and 3 other fields | High correlation |
NWDBMCAEC is highly overall correlated with GC and 3 other fields | High correlation |
BMU Type is highly overall correlated with Trading Unit Name and 6 other fields | High correlation |
GSP Group Id is highly overall correlated with TLF and 3 other fields | High correlation |
GSP Group Name is highly overall correlated with TLF and 3 other fields | High correlation |
Trading Unit Name is highly overall correlated with TLF and 7 other fields | High correlation |
Prod/Cons Flag is highly overall correlated with GC and 6 other fields | High correlation |
Prod/Cons Status is highly overall correlated with GC and 7 other fields | High correlation |
Exempt Export Flag is highly overall correlated with BMU Type and 1 other fields | High correlation |
Base TU Flag is highly overall correlated with GC and 6 other fields | High correlation |
FPN Flag is highly overall correlated with SECALF and 4 other fields | High correlation |
Interconnector Id is highly overall correlated with TLF and 12 other fields | High correlation |
Manual Credit Qualifying Flag is highly overall correlated with GSP Group Id and 2 other fields | High correlation |
Credit Qualifying Status is highly overall correlated with BMU Type and 3 other fields | High correlation |
Exempt Export Flag is highly imbalanced (81.0%) | Imbalance |
Manual Credit Qualifying Flag is highly imbalanced (99.7%) | Imbalance |
Credit Qualifying Status is highly imbalanced (61.4%) | Imbalance |
NGC BMU Name has 3450 (65.5%) missing values | Missing |
GSP Group Id has 1115 (21.2%) missing values | Missing |
GSP Group Name has 1115 (21.2%) missing values | Missing |
Trading Unit Name has 1046 (19.9%) missing values | Missing |
Prod/Cons Flag has 4402 (83.6%) missing values | Missing |
Interconnector Id has 4591 (87.2%) missing values | Missing |
WDCALF is highly skewed (γ1 = -43.22665492) | Skewed |
NWDCALF is highly skewed (γ1 = -40.62443434) | Skewed |
WDBMCAEC is highly skewed (γ1 = -46.60787409) | Skewed |
NWDBMCAEC is highly skewed (γ1 = -42.31463183) | Skewed |
BM Unit ID is uniformly distributed | Uniform |
BMU Name is uniformly distributed | Uniform |
NGC BMU Name is uniformly distributed | Uniform |
BM Unit ID has unique values | Unique |
GC has 3759 (71.4%) zeros | Zeros |
DC has 3152 (59.8%) zeros | Zeros |
WDCALF has 760 (14.4%) zeros | Zeros |
NWDCALF has 764 (14.5%) zeros | Zeros |
SECALF has 1313 (24.9%) zeros | Zeros |
WDBMCAIC has 3500 (66.5%) zeros | Zeros |
NWDBMCAIC has 3500 (66.5%) zeros | Zeros |
WDBMCAEC has 4101 (77.9%) zeros | Zeros |
NWDBMCAEC has 4101 (77.9%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-15 11:59:02.787106 |
|---|---|
| Analysis finished | 2023-04-15 11:59:32.799885 |
| Duration | 30.01 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
BM Unit ID
Categorical
HIGH CARDINALITY UNIFORM UNIQUE
| Distinct | 5267 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 348.6 KiB |
| 2__AALAB000 | 1 |
|---|---|
| C__APURE002 | 1 |
| C__APGEN002 | 1 |
| C__AOXPO009 | 1 |
| C__AOXPO002 | 1 |
| Other values (5262) |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.752611 |
| Min length | 6 |
Characters and Unicode
| Total characters | 56634 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5267 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 2__AALAB000 |
|---|---|
| 2nd row | 2__AALAS000 |
| 3rd row | 2__AALTI000 |
| 4th row | 2__AANGE000 |
| 5th row | 2__AANGE001 |
Common Values
| Value | Count | Frequency (%) |
| 2__AALAB000 | 1 | < 0.1% |
| C__APURE002 | 1 | < 0.1% |
| C__APGEN002 | 1 | < 0.1% |
| C__AOXPO009 | 1 | < 0.1% |
| C__AOXPO002 | 1 | < 0.1% |
| C__ANATP009 | 1 | < 0.1% |
| C__ANATP002 | 1 | < 0.1% |
| C__AMRCY009 | 1 | < 0.1% |
| C__AMRCY002 | 1 | < 0.1% |
| C__AMAGN009 | 1 | < 0.1% |
| Other values (5257) | 5257 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2__aalab000 | 1 | < 0.1% |
| 2__abnrg000 | 1 | < 0.1% |
| 2__aange000 | 1 | < 0.1% |
| 2__aange001 | 1 | < 0.1% |
| 2__aange002 | 1 | < 0.1% |
| 2__aange003 | 1 | < 0.1% |
| 2__aange004 | 1 | < 0.1% |
| 2__aariz000 | 1 | < 0.1% |
| 2__aarru000 | 1 | < 0.1% |
| 2__aavro000 | 1 | < 0.1% |
| Other values (5257) | 5257 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 10892 | |
| _ | 9281 | |
| 2 | 3897 | 6.9% |
| E | 2861 | 5.1% |
| I | 2072 | 3.7% |
| N | 1803 | 3.2% |
| C | 1787 | 3.2% |
| G | 1783 | 3.1% |
| D | 1764 | 3.1% |
| A | 1751 | 3.1% |
| Other values (28) | 18743 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 29318 | |
| Decimal Number | 16828 | |
| Connector Punctuation | 9281 | 16.4% |
| Dash Punctuation | 1207 | 2.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2861 | 9.8% |
| I | 2072 | 7.1% |
| N | 1803 | 6.1% |
| C | 1787 | 6.1% |
| G | 1783 | 6.1% |
| D | 1764 | 6.0% |
| A | 1751 | 6.0% |
| L | 1693 | 5.8% |
| R | 1657 | 5.7% |
| T | 1518 | 5.2% |
| Other values (16) | 10629 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 10892 | |
| 2 | 3897 | 23.2% |
| 1 | 1560 | 9.3% |
| 3 | 168 | 1.0% |
| 4 | 123 | 0.7% |
| 5 | 69 | 0.4% |
| 8 | 44 | 0.3% |
| 9 | 42 | 0.2% |
| 6 | 20 | 0.1% |
| 7 | 13 | 0.1% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 9281 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1207 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 29318 | |
| Common | 27316 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 2861 | 9.8% |
| I | 2072 | 7.1% |
| N | 1803 | 6.1% |
| C | 1787 | 6.1% |
| G | 1783 | 6.1% |
| D | 1764 | 6.0% |
| A | 1751 | 6.0% |
| L | 1693 | 5.8% |
| R | 1657 | 5.7% |
| T | 1518 | 5.2% |
| Other values (16) | 10629 |
Common
| Value | Count | Frequency (%) |
| 0 | 10892 | |
| _ | 9281 | |
| 2 | 3897 | 14.3% |
| 1 | 1560 | 5.7% |
| - | 1207 | 4.4% |
| 3 | 168 | 0.6% |
| 4 | 123 | 0.5% |
| 5 | 69 | 0.3% |
| 8 | 44 | 0.2% |
| 9 | 42 | 0.2% |
| Other values (2) | 33 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 56634 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 10892 | |
| _ | 9281 | |
| 2 | 3897 | 6.9% |
| E | 2861 | 5.1% |
| I | 2072 | 3.7% |
| N | 1803 | 3.2% |
| C | 1787 | 3.2% |
| G | 1783 | 3.1% |
| D | 1764 | 3.1% |
| A | 1751 | 3.1% |
| Other values (28) | 18743 |
BMU Name
Categorical
HIGH CARDINALITY UNIFORM
| Distinct | 5143 |
|---|---|
| Distinct (%) | 97.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 360.1 KiB |
| Flow into UK | 16 |
|---|---|
| Flow from UK | 16 |
| MA Energy Ltd | 14 |
| Cobblestone Energy DMCC | 12 |
| Cobblestone Energy Ltd | 10 |
| Other values (5138) |
Length
| Max length | 30 |
|---|---|
| Median length | 11 |
| Mean length | 12.98671 |
| Min length | 3 |
Characters and Unicode
| Total characters | 68401 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5095 ? |
|---|---|
| Unique (%) | 96.7% |
Sample
| 1st row | ALAB_A |
|---|---|
| 2nd row | ALAS_A |
| 3rd row | 2__AALTI000 |
| 4th row | 2__AANGE000 |
| 5th row | 2__AANGE001 |
Common Values
| Value | Count | Frequency (%) |
| Flow into UK | 16 | 0.3% |
| Flow from UK | 16 | 0.3% |
| MA Energy Ltd | 14 | 0.3% |
| Cobblestone Energy DMCC | 12 | 0.2% |
| Cobblestone Energy Ltd | 10 | 0.2% |
| Flow INTO UK | 6 | 0.1% |
| GRM | 4 | 0.1% |
| Flow FROM UK | 4 | 0.1% |
| Brookfield E | 4 | 0.1% |
| Energidk_G | 3 | 0.1% |
| Other values (5133) | 5178 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| uk | 86 | 1.1% |
| flow | 76 | 1.0% |
| 1 | 69 | 0.9% |
| 2 | 58 | 0.8% |
| 55 | 0.7% | |
| energy | 47 | 0.6% |
| wind | 47 | 0.6% |
| farm | 42 | 0.6% |
| unit | 42 | 0.6% |
| from | 38 | 0.5% |
| Other values (4983) | 6943 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 8762 | 12.8% |
| _ | 7414 | 10.8% |
| A | 3402 | 5.0% |
| E | 3296 | 4.8% |
| 2 | 3039 | 4.4% |
| 2248 | 3.3% | |
| N | 2093 | 3.1% |
| C | 2047 | 3.0% |
| - | 1949 | 2.8% |
| G | 1707 | 2.5% |
| Other values (60) | 32444 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 32138 | |
| Decimal Number | 14532 | |
| Lowercase Letter | 10089 | 14.7% |
| Connector Punctuation | 7414 | 10.8% |
| Space Separator | 2248 | 3.3% |
| Dash Punctuation | 1949 | 2.8% |
| Other Punctuation | 13 | < 0.1% |
| Open Punctuation | 9 | < 0.1% |
| Close Punctuation | 9 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 3402 | 10.6% |
| E | 3296 | 10.3% |
| N | 2093 | 6.5% |
| C | 2047 | 6.4% |
| G | 1707 | 5.3% |
| L | 1707 | 5.3% |
| R | 1613 | 5.0% |
| O | 1544 | 4.8% |
| D | 1507 | 4.7% |
| S | 1461 | 4.5% |
| Other values (16) | 11761 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1239 | |
| o | 1003 | |
| r | 999 | |
| n | 903 | 9.0% |
| t | 815 | 8.1% |
| a | 757 | 7.5% |
| i | 642 | 6.4% |
| l | 550 | 5.5% |
| d | 453 | 4.5% |
| s | 383 | 3.8% |
| Other values (15) | 2345 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 8762 | |
| 2 | 3039 | 20.9% |
| 1 | 1476 | 10.2% |
| 7 | 245 | 1.7% |
| 8 | 232 | 1.6% |
| 9 | 202 | 1.4% |
| 3 | 199 | 1.4% |
| 4 | 164 | 1.1% |
| 6 | 142 | 1.0% |
| 5 | 71 | 0.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 6 | |
| . | 3 | |
| & | 3 | |
| ' | 1 | 7.7% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 7414 |
Space Separator
| Value | Count | Frequency (%) |
| 2248 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1949 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 9 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 9 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 42227 | |
| Common | 26174 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 3402 | 8.1% |
| E | 3296 | 7.8% |
| N | 2093 | 5.0% |
| C | 2047 | 4.8% |
| G | 1707 | 4.0% |
| L | 1707 | 4.0% |
| R | 1613 | 3.8% |
| O | 1544 | 3.7% |
| D | 1507 | 3.6% |
| S | 1461 | 3.5% |
| Other values (41) | 21850 |
Common
| Value | Count | Frequency (%) |
| 0 | 8762 | |
| _ | 7414 | |
| 2 | 3039 | 11.6% |
| 2248 | 8.6% | |
| - | 1949 | 7.4% |
| 1 | 1476 | 5.6% |
| 7 | 245 | 0.9% |
| 8 | 232 | 0.9% |
| 9 | 202 | 0.8% |
| 3 | 199 | 0.8% |
| Other values (9) | 408 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 68401 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 8762 | 12.8% |
| _ | 7414 | 10.8% |
| A | 3402 | 5.0% |
| E | 3296 | 4.8% |
| 2 | 3039 | 4.4% |
| 2248 | 3.3% | |
| N | 2093 | 3.1% |
| C | 2047 | 3.0% |
| - | 1949 | 2.8% |
| G | 1707 | 2.5% |
| Other values (60) | 32444 |
Party Name
Categorical
| Distinct | 349 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 408.9 KiB |
| British Gas Trading Ltd | 318 |
|---|---|
| EDF Energy Customers Ltd | 218 |
| SP Energy Retail Ltd | 143 |
| OVO Electricity Ltd | 127 |
| Statkraft Markets Gmbh | 93 |
| Other values (344) |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 22.471806 |
| Min length | 3 |
Characters and Unicode
| Total characters | 118359 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 59 ? |
|---|---|
| Unique (%) | 1.1% |
Sample
| 1st row | Square1 Energy Limited |
|---|---|
| 2nd row | Clean Energy Supply Ltd |
| 3rd row | Co-operative Energy Limited |
| 4th row | Limejump Energy Limited |
| 5th row | Limejump Energy Limited |
Common Values
| Value | Count | Frequency (%) |
| British Gas Trading Ltd | 318 | 6.0% |
| EDF Energy Customers Ltd | 218 | 4.1% |
| SP Energy Retail Ltd | 143 | 2.7% |
| OVO Electricity Ltd | 127 | 2.4% |
| Statkraft Markets Gmbh | 93 | 1.8% |
| Limejump Energy Limited | 91 | 1.7% |
| Octopus Energy Limited | 90 | 1.7% |
| Drax Energy Solutions Limited | 85 | 1.6% |
| Shell Energy Retail Limited | 84 | 1.6% |
| Utilita Energy Limited | 75 | 1.4% |
| Other values (339) | 3943 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| energy | 2940 | 15.7% |
| limited | 2404 | 12.9% |
| ltd | 1984 | 10.6% |
| trading | 668 | 3.6% |
| gas | 569 | 3.0% |
| power | 452 | 2.4% |
| supply | 414 | 2.2% |
| uk | 406 | 2.2% |
| retail | 325 | 1.7% |
| british | 318 | 1.7% |
| Other values (455) | 8203 |
Most occurring characters
| Value | Count | Frequency (%) |
| 13430 | 11.3% | |
| e | 10075 | 8.5% |
| i | 8367 | 7.1% |
| t | 7550 | 6.4% |
| r | 7026 | 5.9% |
| n | 5691 | 4.8% |
| d | 5371 | 4.5% |
| E | 5311 | 4.5% |
| L | 4694 | 4.0% |
| a | 3964 | 3.3% |
| Other values (55) | 46880 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 75999 | |
| Uppercase Letter | 27736 | 23.4% |
| Space Separator | 13430 | 11.3% |
| Other Punctuation | 581 | 0.5% |
| Open Punctuation | 217 | 0.2% |
| Close Punctuation | 209 | 0.2% |
| Decimal Number | 115 | 0.1% |
| Dash Punctuation | 72 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 10075 | |
| i | 8367 | |
| t | 7550 | |
| r | 7026 | |
| n | 5691 | 7.5% |
| d | 5371 | 7.1% |
| a | 3964 | 5.2% |
| g | 3921 | 5.2% |
| y | 3799 | 5.0% |
| m | 3367 | 4.4% |
| Other values (16) | 16868 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 5311 | |
| L | 4694 | |
| S | 2378 | 8.6% |
| T | 1547 | 5.6% |
| G | 1506 | 5.4% |
| R | 1159 | 4.2% |
| C | 1151 | 4.1% |
| P | 1101 | 4.0% |
| O | 1043 | 3.8% |
| D | 1018 | 3.7% |
| Other values (16) | 6828 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 39 | |
| 4 | 28 | |
| 1 | 19 | |
| 3 | 15 | 13.0% |
| 9 | 14 | 12.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 240 | |
| & | 216 | |
| / | 111 | |
| * | 14 | 2.4% |
Space Separator
| Value | Count | Frequency (%) |
| 13430 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 217 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 209 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 72 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 103735 | |
| Common | 14624 | 12.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 10075 | 9.7% |
| i | 8367 | 8.1% |
| t | 7550 | 7.3% |
| r | 7026 | 6.8% |
| n | 5691 | 5.5% |
| d | 5371 | 5.2% |
| E | 5311 | 5.1% |
| L | 4694 | 4.5% |
| a | 3964 | 3.8% |
| g | 3921 | 3.8% |
| Other values (42) | 41765 |
Common
| Value | Count | Frequency (%) |
| 13430 | ||
| . | 240 | 1.6% |
| ( | 217 | 1.5% |
| & | 216 | 1.5% |
| ) | 209 | 1.4% |
| / | 111 | 0.8% |
| - | 72 | 0.5% |
| 2 | 39 | 0.3% |
| 4 | 28 | 0.2% |
| 1 | 19 | 0.1% |
| Other values (3) | 43 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 118359 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 13430 | 11.3% | |
| e | 10075 | 8.5% |
| i | 8367 | 7.1% |
| t | 7550 | 6.4% |
| r | 7026 | 5.9% |
| n | 5691 | 4.8% |
| d | 5371 | 4.5% |
| E | 5311 | 4.5% |
| L | 4694 | 4.0% |
| a | 3964 | 3.3% |
| Other values (55) | 46880 |
Party ID
Categorical
| Distinct | 349 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 325.0 KiB |
| BRITGAS | 318 |
|---|---|
| LENCO | 218 |
| SPSUP01 | 143 |
| OVOE | 127 |
| STATKRA1 | 93 |
| Other values (344) |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.1591039 |
| Min length | 2 |
Characters and Unicode
| Total characters | 32440 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 59 ? |
|---|---|
| Unique (%) | 1.1% |
Sample
| 1st row | ALAB |
|---|---|
| 2nd row | ALAS |
| 3rd row | VOLA |
| 4th row | ANGEL |
| 5th row | ANGEL |
Common Values
| Value | Count | Frequency (%) |
| BRITGAS | 318 | 6.0% |
| LENCO | 218 | 4.1% |
| SPSUP01 | 143 | 2.7% |
| OVOE | 127 | 2.4% |
| STATKRA1 | 93 | 1.8% |
| ANGEL | 91 | 1.7% |
| MERCURY | 90 | 1.7% |
| HAVEN | 85 | 1.6% |
| FRST01 | 84 | 1.6% |
| UTILITA | 75 | 1.4% |
| Other values (339) | 3943 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| britgas | 318 | 6.0% |
| lenco | 218 | 4.1% |
| spsup01 | 143 | 2.7% |
| ovoe | 127 | 2.4% |
| statkra1 | 93 | 1.8% |
| angel | 91 | 1.7% |
| mercury | 90 | 1.7% |
| haven | 85 | 1.6% |
| frst01 | 84 | 1.6% |
| utilita | 75 | 1.4% |
| Other values (339) | 3943 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 3800 | 11.7% |
| R | 2556 | 7.9% |
| A | 2406 | 7.4% |
| N | 2277 | 7.0% |
| S | 1999 | 6.2% |
| L | 1880 | 5.8% |
| O | 1876 | 5.8% |
| G | 1822 | 5.6% |
| T | 1812 | 5.6% |
| I | 1409 | 4.3% |
| Other values (26) | 10603 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 30827 | |
| Decimal Number | 1613 | 5.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 3800 | |
| R | 2556 | 8.3% |
| A | 2406 | 7.8% |
| N | 2277 | 7.4% |
| S | 1999 | 6.5% |
| L | 1880 | 6.1% |
| O | 1876 | 6.1% |
| G | 1822 | 5.9% |
| T | 1812 | 5.9% |
| I | 1409 | 4.6% |
| Other values (16) | 8990 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 690 | |
| 1 | 637 | |
| 2 | 121 | 7.5% |
| 3 | 42 | 2.6% |
| 5 | 40 | 2.5% |
| 4 | 37 | 2.3% |
| 7 | 17 | 1.1% |
| 6 | 15 | 0.9% |
| 9 | 12 | 0.7% |
| 8 | 2 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 30827 | |
| Common | 1613 | 5.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 3800 | |
| R | 2556 | 8.3% |
| A | 2406 | 7.8% |
| N | 2277 | 7.4% |
| S | 1999 | 6.5% |
| L | 1880 | 6.1% |
| O | 1876 | 6.1% |
| G | 1822 | 5.9% |
| T | 1812 | 5.9% |
| I | 1409 | 4.6% |
| Other values (16) | 8990 |
Common
| Value | Count | Frequency (%) |
| 0 | 690 | |
| 1 | 637 | |
| 2 | 121 | 7.5% |
| 3 | 42 | 2.6% |
| 5 | 40 | 2.5% |
| 4 | 37 | 2.3% |
| 7 | 17 | 1.1% |
| 6 | 15 | 0.9% |
| 9 | 12 | 0.7% |
| 8 | 2 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 32440 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 3800 | 11.7% |
| R | 2556 | 7.9% |
| A | 2406 | 7.4% |
| N | 2277 | 7.0% |
| S | 1999 | 6.2% |
| L | 1880 | 5.8% |
| O | 1876 | 5.8% |
| G | 1822 | 5.6% |
| T | 1812 | 5.6% |
| I | 1409 | 4.3% |
| Other values (26) | 10603 |
BMU Type
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 298.5 KiB |
| G | |
|---|---|
| S | |
| I | |
| T | |
| E | 158 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5267 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | G |
|---|---|
| 2nd row | G |
| 3rd row | G |
| 4th row | G |
| 5th row | S |
Common Values
| Value | Count | Frequency (%) |
| G | 3038 | |
| S | 917 | 17.4% |
| I | 676 | 12.8% |
| T | 439 | 8.3% |
| E | 158 | 3.0% |
| V | 39 | 0.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| g | 3038 | |
| s | 917 | 17.4% |
| i | 676 | 12.8% |
| t | 439 | 8.3% |
| e | 158 | 3.0% |
| v | 39 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 3038 | |
| S | 917 | 17.4% |
| I | 676 | 12.8% |
| T | 439 | 8.3% |
| E | 158 | 3.0% |
| V | 39 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 5267 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 3038 | |
| S | 917 | 17.4% |
| I | 676 | 12.8% |
| T | 439 | 8.3% |
| E | 158 | 3.0% |
| V | 39 | 0.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5267 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 3038 | |
| S | 917 | 17.4% |
| I | 676 | 12.8% |
| T | 439 | 8.3% |
| E | 158 | 3.0% |
| V | 39 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5267 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| G | 3038 | |
| S | 917 | 17.4% |
| I | 676 | 12.8% |
| T | 439 | 8.3% |
| E | 158 | 3.0% |
| V | 39 | 0.7% |
NGC BMU Name
Categorical
HIGH CARDINALITY MISSING UNIFORM
| Distinct | 1817 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 3450 |
| Missing (%) | 65.5% |
| Memory size | 224.0 KiB |
| IIG-LTFD1 | 1 |
|---|---|
| ILD-HELI1 | 1 |
| ILD-HART1 | 1 |
| ILD-GLEN1 | 1 |
| ILD-EPCO1 | 1 |
| Other values (1812) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.3808476 |
| Min length | 5 |
Characters and Unicode
| Total characters | 15228 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1817 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | AG-ALIM03 |
|---|---|
| 2nd row | EAS-AXPO1 |
| 3rd row | EAS-BGS01 |
| 4th row | EAS-BIZ01 |
| 5th row | EAS-BRT01 |
Common Values
| Value | Count | Frequency (%) |
| IIG-LTFD1 | 1 | < 0.1% |
| ILD-HELI1 | 1 | < 0.1% |
| ILD-HART1 | 1 | < 0.1% |
| ILD-GLEN1 | 1 | < 0.1% |
| ILD-EPCO1 | 1 | < 0.1% |
| ILD-ENSC1 | 1 | < 0.1% |
| ILD-ELTR1 | 1 | < 0.1% |
| ILD-EDMK1 | 1 | < 0.1% |
| ILD-EDFT1 | 1 | < 0.1% |
| ILD-DVAL1 | 1 | < 0.1% |
| Other values (1807) | 1807 | |
| (Missing) | 3450 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| iig-ltfd1 | 1 | 0.1% |
| ag-rec06b | 1 | 0.1% |
| eas-bgs01 | 1 | 0.1% |
| eas-biz01 | 1 | 0.1% |
| eas-brt01 | 1 | 0.1% |
| petdg-1 | 1 | 0.1% |
| ag-aeco01 | 1 | 0.1% |
| eas-edf01 | 1 | 0.1% |
| eas-edr01 | 1 | 0.1% |
| eas-eas01 | 1 | 0.1% |
| Other values (1807) | 1807 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 1772 | 11.6% |
| 1 | 1529 | 10.0% |
| E | 1002 | 6.6% |
| I | 908 | 6.0% |
| G | 837 | 5.5% |
| S | 808 | 5.3% |
| D | 749 | 4.9% |
| N | 718 | 4.7% |
| 0 | 675 | 4.4% |
| A | 655 | 4.3% |
| Other values (27) | 5575 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 10842 | |
| Decimal Number | 2614 | 17.2% |
| Dash Punctuation | 1772 | 11.6% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1002 | 9.2% |
| I | 908 | 8.4% |
| G | 837 | 7.7% |
| S | 808 | 7.5% |
| D | 749 | 6.9% |
| N | 718 | 6.6% |
| A | 655 | 6.0% |
| L | 582 | 5.4% |
| T | 494 | 4.6% |
| W | 464 | 4.3% |
| Other values (16) | 3625 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1529 | |
| 0 | 675 | |
| 2 | 256 | 9.8% |
| 3 | 60 | 2.3% |
| 4 | 41 | 1.6% |
| 5 | 18 | 0.7% |
| 6 | 17 | 0.7% |
| 7 | 10 | 0.4% |
| 8 | 6 | 0.2% |
| 9 | 2 | 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1772 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10842 | |
| Common | 4386 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 1002 | 9.2% |
| I | 908 | 8.4% |
| G | 837 | 7.7% |
| S | 808 | 7.5% |
| D | 749 | 6.9% |
| N | 718 | 6.6% |
| A | 655 | 6.0% |
| L | 582 | 5.4% |
| T | 494 | 4.6% |
| W | 464 | 4.3% |
| Other values (16) | 3625 |
Common
| Value | Count | Frequency (%) |
| - | 1772 | |
| 1 | 1529 | |
| 0 | 675 | 15.4% |
| 2 | 256 | 5.8% |
| 3 | 60 | 1.4% |
| 4 | 41 | 0.9% |
| 5 | 18 | 0.4% |
| 6 | 17 | 0.4% |
| 7 | 10 | 0.2% |
| 8 | 6 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15228 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 1772 | 11.6% |
| 1 | 1529 | 10.0% |
| E | 1002 | 6.6% |
| I | 908 | 6.0% |
| G | 837 | 5.5% |
| S | 808 | 5.3% |
| D | 749 | 4.9% |
| N | 718 | 4.7% |
| 0 | 675 | 4.4% |
| A | 655 | 4.3% |
| Other values (27) | 5575 |
GSP Group Id
Categorical
HIGH CORRELATION MISSING
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1115 |
| Missing (%) | 21.2% |
| Memory size | 274.2 KiB |
| _D | |
|---|---|
| _A | |
| _P | |
| _F | |
| _N | |
| Other values (9) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 8304 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | _A |
|---|---|
| 2nd row | _A |
| 3rd row | _A |
| 4th row | _A |
| 5th row | _A |
Common Values
| Value | Count | Frequency (%) |
| _D | 378 | 7.2% |
| _A | 352 | 6.7% |
| _P | 352 | 6.7% |
| _F | 332 | 6.3% |
| _N | 309 | 5.9% |
| _M | 300 | 5.7% |
| _K | 289 | 5.5% |
| _J | 281 | 5.3% |
| _G | 273 | 5.2% |
| _H | 272 | 5.2% |
| Other values (4) | 1014 | |
| (Missing) | 1115 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| d | 378 | 9.1% |
| a | 352 | 8.5% |
| p | 352 | 8.5% |
| f | 332 | 8.0% |
| n | 309 | 7.4% |
| m | 300 | 7.2% |
| k | 289 | 7.0% |
| j | 281 | 6.8% |
| g | 273 | 6.6% |
| h | 272 | 6.6% |
| Other values (4) | 1014 |
Most occurring characters
| Value | Count | Frequency (%) |
| _ | 4152 | |
| D | 378 | 4.6% |
| A | 352 | 4.2% |
| P | 352 | 4.2% |
| F | 332 | 4.0% |
| N | 309 | 3.7% |
| M | 300 | 3.6% |
| K | 289 | 3.5% |
| J | 281 | 3.4% |
| G | 273 | 3.3% |
| Other values (5) | 1286 | 15.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Connector Punctuation | 4152 | |
| Uppercase Letter | 4152 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 378 | 9.1% |
| A | 352 | 8.5% |
| P | 352 | 8.5% |
| F | 332 | 8.0% |
| N | 309 | 7.4% |
| M | 300 | 7.2% |
| K | 289 | 7.0% |
| J | 281 | 6.8% |
| G | 273 | 6.6% |
| H | 272 | 6.6% |
| Other values (4) | 1014 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 4152 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4152 | |
| Latin | 4152 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 378 | 9.1% |
| A | 352 | 8.5% |
| P | 352 | 8.5% |
| F | 332 | 8.0% |
| N | 309 | 7.4% |
| M | 300 | 7.2% |
| K | 289 | 7.0% |
| J | 281 | 6.8% |
| G | 273 | 6.6% |
| H | 272 | 6.6% |
| Other values (4) | 1014 |
Common
| Value | Count | Frequency (%) |
| _ | 4152 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8304 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| _ | 4152 | |
| D | 378 | 4.6% |
| A | 352 | 4.2% |
| P | 352 | 4.2% |
| F | 332 | 4.0% |
| N | 309 | 3.7% |
| M | 300 | 3.6% |
| K | 289 | 3.5% |
| J | 281 | 3.4% |
| G | 273 | 3.3% |
| Other values (5) | 1286 | 15.5% |
GSP Group Name
Categorical
HIGH CORRELATION MISSING
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1115 |
| Missing (%) | 21.2% |
| Memory size | 328.2 KiB |
| Merseyside and North Wales | |
|---|---|
| Eastern GSP Group | |
| NORTH of SCOTLAND GSP | |
| NORTHERN | |
| SOUTH of SCOTLAND GSP | |
| Other values (9) |
Length
| Max length | 26 |
|---|---|
| Median length | 17 |
| Mean length | 15.312139 |
| Min length | 8 |
Characters and Unicode
| Total characters | 63576 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Eastern GSP Group |
|---|---|
| 2nd row | Eastern GSP Group |
| 3rd row | Eastern GSP Group |
| 4th row | Eastern GSP Group |
| 5th row | Eastern GSP Group |
Common Values
| Value | Count | Frequency (%) |
| Merseyside and North Wales | 378 | 7.2% |
| Eastern GSP Group | 352 | 6.7% |
| NORTH of SCOTLAND GSP | 352 | 6.7% |
| NORTHERN | 332 | 6.3% |
| SOUTH of SCOTLAND GSP | 309 | 5.9% |
| Yorkshire Electricity | 300 | 5.7% |
| South Wales | 289 | 5.5% |
| South Eastern | 281 | 5.3% |
| North Western | 273 | 5.2% |
| Southern | 272 | 5.2% |
| Other values (4) | 1014 | |
| (Missing) | 1115 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| south | 1134 | |
| gsp | 1013 | 10.3% |
| north | 1003 | 10.2% |
| wales | 667 | 6.8% |
| of | 661 | 6.7% |
| scotland | 661 | 6.7% |
| eastern | 633 | 6.4% |
| western | 528 | 5.3% |
| midlands | 525 | 5.3% |
| merseyside | 378 | 3.8% |
| Other values (9) | 2671 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5722 | 9.0% | |
| e | 4362 | 6.9% |
| t | 4246 | 6.7% |
| r | 3948 | 6.2% |
| s | 3912 | 6.2% |
| o | 3295 | 5.2% |
| S | 3080 | 4.8% |
| n | 2570 | 4.0% |
| i | 2505 | 3.9% |
| a | 2472 | 3.9% |
| Other values (26) | 27464 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 37164 | |
| Uppercase Letter | 20690 | |
| Space Separator | 5722 | 9.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4362 | |
| t | 4246 | |
| r | 3948 | |
| s | 3912 | |
| o | 3295 | |
| n | 2570 | |
| i | 2505 | |
| a | 2472 | |
| h | 2048 | 5.5% |
| d | 1806 | 4.9% |
| Other values (8) | 6000 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 3080 | |
| N | 2328 | |
| E | 1768 | 8.5% |
| T | 1654 | 8.0% |
| O | 1654 | 8.0% |
| G | 1365 | 6.6% |
| W | 1195 | 5.8% |
| R | 1016 | 4.9% |
| P | 1013 | 4.9% |
| H | 993 | 4.8% |
| Other values (7) | 4624 |
Space Separator
| Value | Count | Frequency (%) |
| 5722 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 57854 | |
| Common | 5722 | 9.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4362 | 7.5% |
| t | 4246 | 7.3% |
| r | 3948 | 6.8% |
| s | 3912 | 6.8% |
| o | 3295 | 5.7% |
| S | 3080 | 5.3% |
| n | 2570 | 4.4% |
| i | 2505 | 4.3% |
| a | 2472 | 4.3% |
| N | 2328 | 4.0% |
| Other values (25) | 25136 |
Common
| Value | Count | Frequency (%) |
| 5722 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 63576 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5722 | 9.0% | |
| e | 4362 | 6.9% |
| t | 4246 | 6.7% |
| r | 3948 | 6.2% |
| s | 3912 | 6.2% |
| o | 3295 | 5.2% |
| S | 3080 | 4.8% |
| n | 2570 | 4.0% |
| i | 2505 | 3.9% |
| a | 2472 | 3.9% |
| Other values (26) | 27464 |
Trading Unit Name
Categorical
HIGH CARDINALITY HIGH CORRELATION MISSING
| Distinct | 52 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 1046 |
| Missing (%) | 19.9% |
| Memory size | 310.6 KiB |
| DEFAULT__D | |
|---|---|
| DEFAULT__P | |
| DEFAULT__A | |
| DEFAULT__F | |
| DEFAULT__N | |
| Other values (47) |
Length
| Max length | 30 |
|---|---|
| Median length | 10 |
| Mean length | 10.379057 |
| Min length | 6 |
Characters and Unicode
| Total characters | 43810 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DEFAULT__A |
|---|---|
| 2nd row | DEFAULT__A |
| 3rd row | DEFAULT__A |
| 4th row | DEFAULT__A |
| 5th row | DEFAULT__A |
Common Values
| Value | Count | Frequency (%) |
| DEFAULT__D | 374 | 7.1% |
| DEFAULT__P | 348 | 6.6% |
| DEFAULT__A | 342 | 6.5% |
| DEFAULT__F | 327 | 6.2% |
| DEFAULT__N | 306 | 5.8% |
| DEFAULT__M | 292 | 5.5% |
| DEFAULT__K | 285 | 5.4% |
| DEFAULT__J | 278 | 5.3% |
| DEFAULT__G | 268 | 5.1% |
| DEFAULT__B | 260 | 4.9% |
| Other values (42) | 1141 | |
| (Missing) | 1046 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| default__d | 374 | 8.2% |
| default__p | 348 | 7.6% |
| default__a | 342 | 7.5% |
| default__f | 327 | 7.2% |
| default__n | 306 | 6.7% |
| default__m | 292 | 6.4% |
| default__k | 285 | 6.2% |
| default__j | 278 | 6.1% |
| default__g | 268 | 5.9% |
| default__b | 260 | 5.7% |
| Other values (64) | 1482 |
Most occurring characters
| Value | Count | Frequency (%) |
| _ | 8140 | |
| D | 4486 | |
| A | 4478 | |
| F | 4404 | |
| E | 4366 | |
| L | 4341 | |
| T | 4162 | |
| U | 4107 | |
| P | 477 | 1.1% |
| N | 382 | 0.9% |
| Other values (46) | 4467 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 33671 | |
| Connector Punctuation | 8140 | 18.6% |
| Lowercase Letter | 1604 | 3.7% |
| Space Separator | 360 | 0.8% |
| Other Punctuation | 23 | 0.1% |
| Decimal Number | 8 | < 0.1% |
| Dash Punctuation | 4 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 4486 | |
| A | 4478 | |
| F | 4404 | |
| E | 4366 | |
| L | 4341 | |
| T | 4162 | |
| U | 4107 | |
| P | 477 | 1.4% |
| N | 382 | 1.1% |
| G | 322 | 1.0% |
| Other values (15) | 2146 |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 239 | |
| o | 216 | |
| e | 160 | |
| n | 151 | |
| a | 148 | |
| r | 146 | |
| i | 129 | |
| w | 92 | 5.7% |
| s | 48 | 3.0% |
| y | 46 | 2.9% |
| Other values (13) | 229 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 12 | |
| . | 5 | |
| ' | 4 | 17.4% |
| / | 2 | 8.7% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 8140 |
Space Separator
| Value | Count | Frequency (%) |
| 360 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 8 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 35275 | |
| Common | 8535 | 19.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 4486 | |
| A | 4478 | |
| F | 4404 | |
| E | 4366 | |
| L | 4341 | |
| T | 4162 | |
| U | 4107 | |
| P | 477 | 1.4% |
| N | 382 | 1.1% |
| G | 322 | 0.9% |
| Other values (38) | 3750 |
Common
| Value | Count | Frequency (%) |
| _ | 8140 | |
| 360 | 4.2% | |
| & | 12 | 0.1% |
| 1 | 8 | 0.1% |
| . | 5 | 0.1% |
| ' | 4 | < 0.1% |
| - | 4 | < 0.1% |
| / | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43810 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| _ | 8140 | |
| D | 4486 | |
| A | 4478 | |
| F | 4404 | |
| E | 4366 | |
| L | 4341 | |
| T | 4162 | |
| U | 4107 | |
| P | 477 | 1.1% |
| N | 382 | 0.9% |
| Other values (46) | 4467 |
Prod/Cons Flag
Categorical
HIGH CORRELATION MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 4402 |
| Missing (%) | 83.6% |
| Memory size | 186.7 KiB |
| P | |
|---|---|
| C |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 865 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | P |
| 4th row | P |
| 5th row | P |
Common Values
| Value | Count | Frequency (%) |
| P | 438 | 8.3% |
| C | 427 | 8.1% |
| (Missing) | 4402 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| p | 438 | |
| c | 427 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 438 | |
| C | 427 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 865 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 438 | |
| C | 427 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 865 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 438 | |
| C | 427 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 865 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 438 | |
| C | 427 |
Prod/Cons Status
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 298.5 KiB |
| C | |
|---|---|
| P |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5267 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | C |
| 4th row | C |
| 5th row | C |
Common Values
| Value | Count | Frequency (%) |
| C | 4536 | |
| P | 731 | 13.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| c | 4536 | |
| p | 731 | 13.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 4536 | |
| P | 731 | 13.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 5267 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 4536 | |
| P | 731 | 13.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5267 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 4536 | |
| P | 731 | 13.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5267 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 4536 | |
| P | 731 | 13.9% |
TLF
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0022847549 |
| Minimum | -0.0261238 |
|---|---|
| Maximum | 0.0148608 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1553 |
| Negative (%) | 29.5% |
| Memory size | 41.3 KiB |
Quantile statistics
| Minimum | -0.0261238 |
|---|---|
| 5-th percentile | -0.0261238 |
| Q1 | -0.0037297 |
| median | 0.0064211 |
| Q3 | 0.0073762 |
| 95-th percentile | 0.0145587 |
| Maximum | 0.0148608 |
| Range | 0.0409846 |
| Interquartile range (IQR) | 0.0111059 |
Descriptive statistics
| Standard deviation | 0.010762974 |
|---|---|
| Coefficient of variation (CV) | 4.7107786 |
| Kurtosis | 1.4374336 |
| Mean | 0.0022847549 |
| Median Absolute Deviation (MAD) | 0.0058645 |
| Skewness | -1.356837 |
| Sum | 12.033804 |
| Variance | 0.00011584162 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 0.0064211 | 778 | |
| 0.0070704 | 465 | |
| -0.0261238 | 442 | |
| -0.0042622 | 426 | 8.1% |
| 0.0122856 | 410 | 7.8% |
| 0.002763 | 390 | 7.4% |
| -0.0037297 | 348 | 6.6% |
| -0.0083696 | 337 | 6.4% |
| 0.0073762 | 305 | 5.8% |
| 0.0061409 | 301 | 5.7% |
| Other values (4) | 1065 |
| Value | Count | Frequency (%) |
| -0.0261238 | 442 | |
| -0.0083696 | 337 | |
| -0.0042622 | 426 | |
| -0.0037297 | 348 | |
| 0.0008159 | 293 | 5.6% |
| 0.002763 | 390 | |
| 0.0061409 | 301 | 5.7% |
| 0.0064211 | 778 | |
| 0.0070704 | 465 | |
| 0.0073762 | 305 | 5.8% |
| Value | Count | Frequency (%) |
| 0.0148608 | 262 | 5.0% |
| 0.0145587 | 245 | 4.7% |
| 0.0125248 | 265 | 5.0% |
| 0.0122856 | 410 | |
| 0.0073762 | 305 | 5.8% |
| 0.0070704 | 465 | |
| 0.0064211 | 778 | |
| 0.0061409 | 301 | 5.7% |
| 0.002763 | 390 | |
| 0.0008159 | 293 | 5.6% |
GC
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 672 |
|---|---|
| Distinct (%) | 12.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91.157057 |
| Minimum | 0 |
|---|---|
| Maximum | 4000 |
| Zeros | 3759 |
| Zeros (%) | 71.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 6 |
| 95-th percentile | 897.428 |
| Maximum | 4000 |
| Range | 4000 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 317.92134 |
|---|---|
| Coefficient of variation (CV) | 3.4876218 |
| Kurtosis | 36.165946 |
| Mean | 91.157057 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.2399865 |
| Sum | 480124.22 |
| Variance | 101073.98 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3759 | |
| 1000 | 169 | 3.2% |
| 49 | 56 | 1.1% |
| 2000 | 47 | 0.9% |
| 500 | 45 | 0.9% |
| 50 | 44 | 0.8% |
| 20 | 41 | 0.8% |
| 40 | 20 | 0.4% |
| 25 | 20 | 0.4% |
| 2 | 17 | 0.3% |
| Other values (662) | 1049 | 19.9% |
| Value | Count | Frequency (%) |
| 0 | 3759 | |
| 0.02 | 6 | 0.1% |
| 0.04 | 2 | < 0.1% |
| 0.06 | 1 | < 0.1% |
| 0.08 | 4 | 0.1% |
| 0.1 | 1 | < 0.1% |
| 0.12 | 2 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.2 | 1 | < 0.1% |
| 0.22 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 4000 | 4 | 0.1% |
| 3000 | 4 | 0.1% |
| 2880 | 1 | < 0.1% |
| 2000 | 47 | |
| 1760 | 1 | < 0.1% |
| 1710.204 | 1 | < 0.1% |
| 1500 | 3 | 0.1% |
| 1478.2 | 1 | < 0.1% |
| 1440 | 1 | < 0.1% |
| 1400 | 5 | 0.1% |
DC
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 1020 |
|---|---|
| Distinct (%) | 19.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -80.589158 |
| Minimum | -4000 |
|---|---|
| Maximum | 0 |
| Zeros | 3152 |
| Zeros (%) | 59.8% |
| Negative | 2115 |
| Negative (%) | 40.2% |
| Memory size | 41.3 KiB |
Quantile statistics
| Minimum | -4000 |
|---|---|
| 5-th percentile | -589.976 |
| Q1 | -4.177 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 0 |
| Range | 4000 |
| Interquartile range (IQR) | 4.177 |
Descriptive statistics
| Standard deviation | 306.43307 |
|---|---|
| Coefficient of variation (CV) | -3.8024106 |
| Kurtosis | 43.118175 |
| Mean | -80.589158 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -5.6985584 |
| Sum | -424463.1 |
| Variance | 93901.227 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3152 | |
| -1000 | 167 | 3.2% |
| -2 | 112 | 2.1% |
| -1 | 75 | 1.4% |
| -2000 | 47 | 0.9% |
| -500 | 42 | 0.8% |
| -0.1 | 33 | 0.6% |
| -10 | 28 | 0.5% |
| -6 | 26 | 0.5% |
| -0.2 | 25 | 0.5% |
| Other values (1010) | 1560 |
| Value | Count | Frequency (%) |
| -4000 | 5 | 0.1% |
| -3000 | 2 | < 0.1% |
| -2000 | 47 | |
| -1500 | 2 | < 0.1% |
| -1480 | 3 | 0.1% |
| -1449.88 | 1 | < 0.1% |
| -1400 | 2 | < 0.1% |
| -1200 | 4 | 0.1% |
| -1150 | 2 | < 0.1% |
| -1114.47 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 3152 | |
| -0.002 | 1 | < 0.1% |
| -0.004 | 5 | 0.1% |
| -0.006 | 3 | 0.1% |
| -0.012 | 1 | < 0.1% |
| -0.016 | 1 | < 0.1% |
| -0.018 | 2 | < 0.1% |
| -0.02 | 24 | 0.5% |
| -0.028 | 1 | < 0.1% |
| -0.036 | 1 | < 0.1% |
WDCALF
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 1286 |
|---|---|
| Distinct (%) | 24.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.25342438 |
| Minimum | -152.656 |
|---|---|
| Maximum | 1 |
| Zeros | 760 |
| Zeros (%) | 14.4% |
| Negative | 66 |
| Negative (%) | 1.3% |
| Memory size | 41.3 KiB |
Quantile statistics
| Minimum | -152.656 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.3852 |
| median | 0.4166 |
| Q3 | 0.439 |
| 95-th percentile | 0.58944 |
| Maximum | 1 |
| Range | 153.656 |
| Interquartile range (IQR) | 0.0538 |
Descriptive statistics
| Standard deviation | 2.7936352 |
|---|---|
| Coefficient of variation (CV) | 11.023546 |
| Kurtosis | 2094.3599 |
| Mean | 0.25342438 |
| Median Absolute Deviation (MAD) | 0.0224 |
| Skewness | -43.226655 |
| Sum | 1334.7862 |
| Variance | 7.8043979 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 760 | 14.4% |
| 0.4 | 398 | 7.6% |
| 0.4471 | 265 | 5.0% |
| 0.4313 | 238 | 4.5% |
| 0.419 | 235 | 4.5% |
| 0.3955 | 226 | 4.3% |
| 0.4016 | 191 | 3.6% |
| 0.4126 | 190 | 3.6% |
| 0.4166 | 189 | 3.6% |
| 0.4277 | 182 | 3.5% |
| Other values (1276) | 2393 |
| Value | Count | Frequency (%) |
| -152.656 | 1 | |
| -100.2359 | 1 | |
| -68.4484 | 1 | |
| -26.6626 | 1 | |
| -23.5 | 1 | |
| -16.651 | 1 | |
| -13.546 | 1 | |
| -12.6936 | 1 | |
| -7.4493 | 1 | |
| -7.4166 | 1 |
| Value | Count | Frequency (%) |
| 1 | 3 | |
| 0.999 | 1 | < 0.1% |
| 0.9935 | 1 | < 0.1% |
| 0.9497 | 1 | < 0.1% |
| 0.9077 | 1 | < 0.1% |
| 0.9029 | 1 | < 0.1% |
| 0.9 | 1 | < 0.1% |
| 0.874 | 1 | < 0.1% |
| 0.8613 | 1 | < 0.1% |
| 0.8598 | 1 | < 0.1% |
NWDCALF
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 1272 |
|---|---|
| Distinct (%) | 24.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.22117716 |
| Minimum | -126.8879 |
|---|---|
| Maximum | 7.595 |
| Zeros | 764 |
| Zeros (%) | 14.5% |
| Negative | 68 |
| Negative (%) | 1.3% |
| Memory size | 41.3 KiB |
Quantile statistics
| Minimum | -126.8879 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.32895 |
| median | 0.3719 |
| Q3 | 0.4 |
| 95-th percentile | 0.51654 |
| Maximum | 7.595 |
| Range | 134.4829 |
| Interquartile range (IQR) | 0.07105 |
Descriptive statistics
| Standard deviation | 2.4453487 |
|---|---|
| Coefficient of variation (CV) | 11.056064 |
| Kurtosis | 1859.1496 |
| Mean | 0.22117716 |
| Median Absolute Deviation (MAD) | 0.0281 |
| Skewness | -40.624434 |
| Sum | 1164.9401 |
| Variance | 5.9797305 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 764 | 14.5% |
| 0.4 | 400 | 7.6% |
| 0.3957 | 265 | 5.0% |
| 0.3739 | 239 | 4.5% |
| 0.3721 | 236 | 4.5% |
| 0.3487 | 226 | 4.3% |
| 0.3459 | 191 | 3.6% |
| 0.3692 | 190 | 3.6% |
| 0.3575 | 189 | 3.6% |
| 0.3807 | 182 | 3.5% |
| Other values (1262) | 2385 |
| Value | Count | Frequency (%) |
| -126.8879 | 1 | < 0.1% |
| -92.683 | 1 | < 0.1% |
| -60.6776 | 1 | < 0.1% |
| -25.6047 | 1 | < 0.1% |
| -23.5 | 1 | < 0.1% |
| -15.269 | 1 | < 0.1% |
| -13.9843 | 1 | < 0.1% |
| -13.7861 | 1 | < 0.1% |
| -8.3896 | 1 | < 0.1% |
| -7.9746 | 6 |
| Value | Count | Frequency (%) |
| 7.595 | 1 | < 0.1% |
| 1 | 3 | |
| 0.999 | 1 | < 0.1% |
| 0.9925 | 1 | < 0.1% |
| 0.9497 | 1 | < 0.1% |
| 0.9215 | 1 | < 0.1% |
| 0.9029 | 1 | < 0.1% |
| 0.9 | 1 | < 0.1% |
| 0.874 | 1 | < 0.1% |
| 0.8613 | 1 | < 0.1% |
SECALF
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 158 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.17210387 |
| Minimum | 0 |
|---|---|
| Maximum | 0.8165 |
| Zeros | 1313 |
| Zeros (%) | 24.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.00155 |
| median | 0.23 |
| Q3 | 0.23 |
| 95-th percentile | 0.23 |
| Maximum | 0.8165 |
| Range | 0.8165 |
| Interquartile range (IQR) | 0.22845 |
Descriptive statistics
| Standard deviation | 0.10169973 |
|---|---|
| Coefficient of variation (CV) | 0.59092064 |
| Kurtosis | -0.26111644 |
| Mean | 0.17210387 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.95155017 |
| Sum | 906.4711 |
| Variance | 0.010342835 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.23 | 3793 | |
| 0 | 1313 | 24.9% |
| 0.2142 | 2 | < 0.1% |
| 0.1525 | 2 | < 0.1% |
| 0.0007 | 2 | < 0.1% |
| 0.1614 | 2 | < 0.1% |
| 0.2523 | 2 | < 0.1% |
| 0.2443 | 1 | < 0.1% |
| 0.3045 | 1 | < 0.1% |
| 0.1879 | 1 | < 0.1% |
| Other values (148) | 148 | 2.8% |
| Value | Count | Frequency (%) |
| 0 | 1313 | |
| 0.0007 | 2 | < 0.1% |
| 0.0009 | 1 | < 0.1% |
| 0.001 | 1 | < 0.1% |
| 0.0021 | 1 | < 0.1% |
| 0.0076 | 1 | < 0.1% |
| 0.0079 | 1 | < 0.1% |
| 0.0108 | 1 | < 0.1% |
| 0.0109 | 1 | < 0.1% |
| 0.0125 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.8165 | 1 | |
| 0.6754 | 1 | |
| 0.5896 | 1 | |
| 0.5114 | 1 | |
| 0.5112 | 1 | |
| 0.4756 | 1 | |
| 0.4279 | 1 | |
| 0.4116 | 1 | |
| 0.4064 | 1 | |
| 0.382 | 1 |
WDBMCAIC
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 1360 |
|---|---|
| Distinct (%) | 25.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -6.4870797 |
| Minimum | -742.181 |
|---|---|
| Maximum | 213.301 |
| Zeros | 3500 |
| Zeros (%) | 66.5% |
| Negative | 1720 |
| Negative (%) | 32.7% |
| Memory size | 41.3 KiB |
Quantile statistics
| Minimum | -742.181 |
|---|---|
| 5-th percentile | -29.6855 |
| Q1 | -0.4 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 213.301 |
| Range | 955.482 |
| Interquartile range (IQR) | 0.4 |
Descriptive statistics
| Standard deviation | 31.515497 |
|---|---|
| Coefficient of variation (CV) | -4.8581948 |
| Kurtosis | 116.34563 |
| Mean | -6.4870797 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -8.5946507 |
| Sum | -34167.449 |
| Variance | 993.22656 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3500 | |
| -0.8 | 34 | 0.6% |
| -0.4 | 28 | 0.5% |
| -1.2 | 16 | 0.3% |
| -0.009 | 14 | 0.3% |
| -2 | 14 | 0.3% |
| -8 | 13 | 0.2% |
| -4 | 13 | 0.2% |
| -2.4 | 12 | 0.2% |
| -0.04 | 10 | 0.2% |
| Other values (1350) | 1613 |
| Value | Count | Frequency (%) |
| -742.181 | 1 | |
| -535.931 | 1 | |
| -481.323 | 1 | |
| -417.56 | 1 | |
| -341.442 | 1 | |
| -336.78 | 1 | |
| -325.65 | 1 | |
| -322.886 | 1 | |
| -316.444 | 1 | |
| -297.167 | 1 |
| Value | Count | Frequency (%) |
| 213.301 | 1 | |
| 183.442 | 1 | |
| 154.488 | 1 | |
| 63.319 | 1 | |
| 45.797 | 1 | |
| 36.574 | 1 | |
| 30.071 | 1 | |
| 23.28 | 1 | |
| 21.766 | 1 | |
| 21.36 | 1 |
NWDBMCAIC
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 1337 |
|---|---|
| Distinct (%) | 25.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -5.7315136 |
| Minimum | -653.346 |
|---|---|
| Maximum | 204.838 |
| Zeros | 3500 |
| Zeros (%) | 66.5% |
| Negative | 1717 |
| Negative (%) | 32.6% |
| Memory size | 41.3 KiB |
Quantile statistics
| Minimum | -653.346 |
|---|---|
| 5-th percentile | -26.2545 |
| Q1 | -0.3715 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 204.838 |
| Range | 858.184 |
| Interquartile range (IQR) | 0.3715 |
Descriptive statistics
| Standard deviation | 27.792968 |
|---|---|
| Coefficient of variation (CV) | -4.8491499 |
| Kurtosis | 117.1748 |
| Mean | -5.7315136 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -8.5608354 |
| Sum | -30187.882 |
| Variance | 772.4491 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3500 | |
| -0.8 | 34 | 0.6% |
| -0.4 | 30 | 0.6% |
| -1.2 | 16 | 0.3% |
| -2 | 14 | 0.3% |
| -0.007 | 13 | 0.2% |
| -8 | 13 | 0.2% |
| -4 | 13 | 0.2% |
| -2.4 | 12 | 0.2% |
| -4.4 | 9 | 0.2% |
| Other values (1327) | 1613 |
| Value | Count | Frequency (%) |
| -653.346 | 1 | |
| -472.316 | 1 | |
| -434.588 | 1 | |
| -338.39 | 1 | |
| -325.68 | 1 | |
| -311.021 | 1 | |
| -302.695 | 1 | |
| -283.986 | 1 | |
| -276.486 | 1 | |
| -270.078 | 1 |
| Value | Count | Frequency (%) |
| 204.838 | 1 | |
| 162.616 | 1 | |
| 154.488 | 1 | |
| 64.444 | 1 | |
| 38.066 | 1 | |
| 37.758 | 1 | |
| 27.805 | 1 | |
| 23.787 | 1 | |
| 21.36 | 1 | |
| 18.516 | 1 |
WDBMCAEC
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 887 |
|---|---|
| Distinct (%) | 16.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.7303277 |
| Minimum | -6964.167 |
|---|---|
| Maximum | 513.2 |
| Zeros | 4101 |
| Zeros (%) | 77.9% |
| Negative | 47 |
| Negative (%) | 0.9% |
| Memory size | 41.3 KiB |
Quantile statistics
| Minimum | -6964.167 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 35.9436 |
| Maximum | 513.2 |
| Range | 7477.367 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 114.40567 |
|---|---|
| Coefficient of variation (CV) | 24.185569 |
| Kurtosis | 2698.0438 |
| Mean | 4.7303277 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -46.607874 |
| Sum | 24914.636 |
| Variance | 13088.657 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4101 | |
| 11.27 | 46 | 0.9% |
| 11.5 | 14 | 0.3% |
| 8 | 12 | 0.2% |
| 10 | 10 | 0.2% |
| 20 | 9 | 0.2% |
| 16 | 8 | 0.2% |
| 9.2 | 8 | 0.2% |
| 43.2 | 7 | 0.1% |
| 12 | 6 | 0.1% |
| Other values (877) | 1046 | 19.9% |
| Value | Count | Frequency (%) |
| -6964.167 | 1 | |
| -2666.275 | 1 | |
| -2190.349 | 1 | |
| -744.93 | 1 | |
| -631.244 | 1 | |
| -533.252 | 1 | |
| -486.897 | 1 | |
| -311.501 | 1 | |
| -266.416 | 1 | |
| -199.524 | 1 |
| Value | Count | Frequency (%) |
| 513.2 | 1 | |
| 494.261 | 1 | |
| 480 | 1 | |
| 471.168 | 1 | |
| 391.776 | 1 | |
| 380 | 1 | |
| 368 | 1 | |
| 362 | 1 | |
| 351.904 | 1 | |
| 340 | 1 |
NWDBMCAEC
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 893 |
|---|---|
| Distinct (%) | 17.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.8655215 |
| Minimum | -5788.626 |
|---|---|
| Maximum | 513.2 |
| Zeros | 4101 |
| Zeros (%) | 77.9% |
| Negative | 49 |
| Negative (%) | 0.9% |
| Memory size | 41.3 KiB |
Quantile statistics
| Minimum | -5788.626 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 33.9854 |
| Maximum | 513.2 |
| Range | 6301.826 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 99.032756 |
|---|---|
| Coefficient of variation (CV) | 20.353986 |
| Kurtosis | 2328.002 |
| Mean | 4.8655215 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -42.314632 |
| Sum | 25626.702 |
| Variance | 9807.4868 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4101 | |
| 11.27 | 46 | 0.9% |
| 11.5 | 14 | 0.3% |
| 8 | 12 | 0.2% |
| 10 | 10 | 0.2% |
| 20 | 9 | 0.2% |
| 9.2 | 8 | 0.2% |
| 16 | 8 | 0.2% |
| 43.2 | 7 | 0.1% |
| 128 | 6 | 0.1% |
| Other values (883) | 1046 | 19.9% |
| Value | Count | Frequency (%) |
| -5788.626 | 1 | |
| -2465.368 | 1 | |
| -1941.683 | 1 | |
| -758.16 | 1 | |
| -651.668 | 1 | |
| -512.094 | 1 | |
| -486.897 | 1 | |
| -338.311 | 1 | |
| -244.304 | 1 | |
| -162.715 | 1 |
| Value | Count | Frequency (%) |
| 513.2 | 1 | |
| 480 | 1 | |
| 471.168 | 1 | |
| 391.776 | 1 | |
| 380 | 1 | |
| 368 | 1 | |
| 362 | 1 | |
| 351.904 | 1 | |
| 340 | 1 | |
| 332 | 1 |
Exempt Export Flag
Boolean
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.3 KiB |
| False | |
|---|---|
| True | 153 |
| Value | Count | Frequency (%) |
| False | 5114 | |
| True | 153 | 2.9% |
Base TU Flag
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.3 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 4067 | |
| False | 1200 | 22.8% |
FPN Flag
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.3 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 3572 | |
| True | 1695 |
Interconnector Id
Categorical
HIGH CORRELATION MISSING
| Distinct | 8 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 4591 |
| Missing (%) | 87.2% |
| Memory size | 185.3 KiB |
| FRANCE | |
|---|---|
| BRITNED | |
| IFA2 | |
| NEMOLINK | |
| ELECLINK | |
| Other values (3) |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.1715976 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4172 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BRITNED |
|---|---|
| 2nd row | ELECLINK |
| 3rd row | EWIC |
| 4th row | FRANCE |
| 5th row | IFA2 |
Common Values
| Value | Count | Frequency (%) |
| FRANCE | 154 | 2.9% |
| BRITNED | 132 | 2.5% |
| IFA2 | 124 | 2.4% |
| NEMOLINK | 100 | 1.9% |
| ELECLINK | 84 | 1.6% |
| EWIC | 38 | 0.7% |
| MOYLE | 36 | 0.7% |
| NSL | 8 | 0.2% |
| (Missing) | 4591 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| france | 154 | |
| britned | 132 | |
| ifa2 | 124 | |
| nemolink | 100 | |
| eleclink | 84 | |
| ewic | 38 | 5.6% |
| moyle | 36 | 5.3% |
| nsl | 8 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 628 | |
| N | 578 | |
| I | 478 | |
| L | 312 | |
| R | 286 | 6.9% |
| F | 278 | 6.7% |
| A | 278 | 6.7% |
| C | 276 | 6.6% |
| K | 184 | 4.4% |
| M | 136 | 3.3% |
| Other values (8) | 738 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4048 | |
| Decimal Number | 124 | 3.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 628 | |
| N | 578 | |
| I | 478 | |
| L | 312 | |
| R | 286 | |
| F | 278 | |
| A | 278 | |
| C | 276 | |
| K | 184 | 4.5% |
| M | 136 | 3.4% |
| Other values (7) | 614 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 124 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4048 | |
| Common | 124 | 3.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 628 | |
| N | 578 | |
| I | 478 | |
| L | 312 | |
| R | 286 | |
| F | 278 | |
| A | 278 | |
| C | 276 | |
| K | 184 | 4.5% |
| M | 136 | 3.4% |
| Other values (7) | 614 |
Common
| Value | Count | Frequency (%) |
| 2 | 124 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4172 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 628 | |
| N | 578 | |
| I | 478 | |
| L | 312 | |
| R | 286 | 6.9% |
| F | 278 | 6.7% |
| A | 278 | 6.7% |
| C | 276 | 6.6% |
| K | 184 | 4.4% |
| M | 136 | 3.3% |
| Other values (8) | 738 |
Effective From
Date
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 41.3 KiB |
| Minimum | 2023-01-03 00:00:00 |
|---|---|
| Maximum | 2023-07-03 00:00:00 |
Histogram with fixed size bins (bins=2)
Manual Credit Qualifying Flag
Boolean
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.3 KiB |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) |
| False | 5266 | |
| True | 1 | < 0.1% |
Credit Qualifying Status
Boolean
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 39 |
| Missing (%) | 0.7% |
| Memory size | 10.4 KiB |
| False | |
|---|---|
| True | 395 |
| (Missing) | 39 |
| Value | Count | Frequency (%) |
| False | 4833 | |
| True | 395 | 7.5% |
| (Missing) | 39 | 0.7% |
| TLF | GC | DC | WDCALF | NWDCALF | SECALF | WDBMCAIC | NWDBMCAIC | WDBMCAEC | NWDBMCAEC | BMU Type | GSP Group Id | GSP Group Name | Trading Unit Name | Prod/Cons Flag | Prod/Cons Status | Exempt Export Flag | Base TU Flag | FPN Flag | Interconnector Id | Manual Credit Qualifying Flag | Credit Qualifying Status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TLF | 1.000 | -0.069 | -0.031 | 0.110 | 0.046 | 0.005 | 0.014 | 0.016 | -0.130 | -0.131 | 0.196 | 0.999 | 0.999 | 0.995 | 0.000 | 0.162 | 0.102 | 0.262 | 0.201 | 0.997 | 0.000 | 0.175 |
| GC | -0.069 | 1.000 | -0.061 | -0.420 | -0.179 | -0.459 | -0.133 | -0.135 | 0.710 | 0.708 | 0.285 | 0.000 | 0.000 | 0.471 | 0.734 | 0.688 | 0.036 | 0.506 | 0.396 | 0.219 | 0.000 | 0.256 |
| DC | -0.031 | -0.061 | 1.000 | -0.028 | -0.152 | 0.311 | 0.736 | 0.734 | -0.189 | -0.187 | 0.280 | 0.040 | 0.040 | 0.000 | 0.753 | 0.098 | 0.029 | 0.440 | 0.373 | 0.205 | 0.000 | 0.066 |
| WDCALF | 0.110 | -0.420 | -0.028 | 1.000 | 0.843 | 0.588 | -0.371 | -0.370 | -0.127 | -0.127 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 |
| NWDCALF | 0.046 | -0.179 | -0.152 | 0.843 | 1.000 | 0.313 | -0.507 | -0.511 | 0.151 | 0.153 | 0.000 | 0.009 | 0.009 | 0.000 | 1.000 | 0.000 | 0.000 | 0.011 | 0.000 | 1.000 | 0.000 | 0.000 |
| SECALF | 0.005 | -0.459 | 0.311 | 0.588 | 0.313 | 1.000 | 0.041 | 0.046 | -0.213 | -0.215 | 0.443 | 0.018 | 0.018 | 0.219 | 0.000 | 0.684 | 0.274 | 0.931 | 0.691 | 1.000 | 0.000 | 0.489 |
| WDBMCAIC | 0.014 | -0.133 | 0.736 | -0.371 | -0.507 | 0.041 | 1.000 | 0.997 | -0.361 | -0.358 | 0.044 | 0.028 | 0.028 | 0.097 | 0.000 | 0.023 | 0.000 | 0.061 | 0.207 | 1.000 | 0.000 | 0.000 |
| NWDBMCAIC | 0.016 | -0.135 | 0.734 | -0.370 | -0.511 | 0.046 | 0.997 | 1.000 | -0.362 | -0.363 | 0.051 | 0.028 | 0.028 | 0.092 | 0.000 | 0.021 | 0.000 | 0.062 | 0.190 | 1.000 | 0.000 | 0.000 |
| WDBMCAEC | -0.130 | 0.710 | -0.189 | -0.127 | 0.151 | -0.213 | -0.361 | -0.362 | 1.000 | 0.997 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.007 | 1.000 | 0.000 | 0.000 |
| NWDBMCAEC | -0.131 | 0.708 | -0.187 | -0.127 | 0.153 | -0.215 | -0.358 | -0.363 | 0.997 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 |
| BMU Type | 0.196 | 0.285 | 0.280 | 0.000 | 0.000 | 0.443 | 0.044 | 0.051 | 0.000 | 0.000 | 1.000 | 0.142 | 0.142 | 0.605 | 0.000 | 0.700 | 0.751 | 0.982 | 0.708 | 1.000 | 0.018 | 0.787 |
| GSP Group Id | 0.999 | 0.000 | 0.040 | 0.000 | 0.009 | 0.018 | 0.028 | 0.028 | 0.000 | 0.000 | 0.142 | 1.000 | 1.000 | 0.999 | 0.304 | 0.087 | 0.095 | 0.068 | 0.067 | 0.000 | 1.000 | 0.098 |
| GSP Group Name | 0.999 | 0.000 | 0.040 | 0.000 | 0.009 | 0.018 | 0.028 | 0.028 | 0.000 | 0.000 | 0.142 | 1.000 | 1.000 | 0.999 | 0.304 | 0.087 | 0.095 | 0.068 | 0.067 | 0.000 | 1.000 | 0.098 |
| Trading Unit Name | 0.995 | 0.471 | 0.000 | 0.000 | 0.000 | 0.219 | 0.097 | 0.092 | 0.000 | 0.000 | 0.605 | 0.999 | 0.999 | 1.000 | 0.345 | 0.819 | 0.158 | 0.994 | 0.340 | 0.000 | 1.000 | 0.687 |
| Prod/Cons Flag | 0.000 | 0.734 | 0.753 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.304 | 0.304 | 0.345 | 1.000 | 0.998 | 0.000 | 0.000 | 0.059 | 0.000 | 0.000 | 0.000 |
| Prod/Cons Status | 0.162 | 0.688 | 0.098 | 0.000 | 0.000 | 0.684 | 0.023 | 0.021 | 0.000 | 0.000 | 0.700 | 0.087 | 0.087 | 0.819 | 0.998 | 1.000 | 0.190 | 0.661 | 0.530 | 0.000 | 0.000 | 0.582 |
| Exempt Export Flag | 0.102 | 0.036 | 0.029 | 0.000 | 0.000 | 0.274 | 0.000 | 0.000 | 0.000 | 0.000 | 0.751 | 0.095 | 0.095 | 0.158 | 0.000 | 0.190 | 1.000 | 0.000 | 0.174 | 1.000 | 0.000 | 0.472 |
| Base TU Flag | 0.262 | 0.506 | 0.440 | 0.000 | 0.011 | 0.931 | 0.061 | 0.062 | 0.000 | 0.000 | 0.982 | 0.068 | 0.068 | 0.994 | 0.000 | 0.661 | 0.000 | 1.000 | 0.668 | 1.000 | 0.000 | 0.376 |
| FPN Flag | 0.201 | 0.396 | 0.373 | 0.000 | 0.000 | 0.691 | 0.207 | 0.190 | 0.007 | 0.000 | 0.708 | 0.067 | 0.067 | 0.340 | 0.059 | 0.530 | 0.174 | 0.668 | 1.000 | 1.000 | 0.000 | 0.418 |
| Interconnector Id | 0.997 | 0.219 | 0.205 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 |
| Manual Credit Qualifying Flag | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.018 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 |
| Credit Qualifying Status | 0.175 | 0.256 | 0.066 | 0.000 | 0.000 | 0.489 | 0.000 | 0.000 | 0.000 | 0.000 | 0.787 | 0.098 | 0.098 | 0.687 | 0.000 | 0.582 | 0.472 | 0.376 | 0.418 | 1.000 | 0.000 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| BM Unit ID | BMU Name | Party Name | Party ID | BMU Type | NGC BMU Name | GSP Group Id | GSP Group Name | Trading Unit Name | Prod/Cons Flag | Prod/Cons Status | TLF | GC | DC | WDCALF | NWDCALF | SECALF | WDBMCAIC | NWDBMCAIC | WDBMCAEC | NWDBMCAEC | Exempt Export Flag | Base TU Flag | FPN Flag | Interconnector Id | Effective From | Manual Credit Qualifying Flag | Credit Qualifying Status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2__AALAB000 | ALAB_A | Square1 Energy Limited | ALAB | G | NaN | _A | Eastern GSP Group | DEFAULT__A | NaN | C | 0.002763 | 0.000 | 0.00 | 0.3955 | 0.3487 | 0.23 | 0.000 | 0.000 | 0.000 | 0.000 | F | T | F | NaN | 2023-01-03 | F | F |
| 1 | 2__AALAS000 | ALAS_A | Clean Energy Supply Ltd | ALAS | G | NaN | _A | Eastern GSP Group | DEFAULT__A | NaN | C | 0.002763 | 0.000 | 0.00 | 0.3955 | 0.3487 | 0.23 | 0.000 | 0.000 | 0.000 | 0.000 | F | T | F | NaN | 2023-01-03 | F | F |
| 2 | 2__AALTI000 | 2__AALTI000 | Co-operative Energy Limited | VOLA | G | NaN | _A | Eastern GSP Group | DEFAULT__A | NaN | C | 0.002763 | 0.000 | -4.38 | 0.3955 | 0.3487 | 0.23 | -1.732 | -1.527 | 0.000 | 0.000 | F | T | F | NaN | 2023-01-03 | F | F |
| 3 | 2__AANGE000 | 2__AANGE000 | Limejump Energy Limited | ANGEL | G | NaN | _A | Eastern GSP Group | DEFAULT__A | NaN | C | 0.002763 | 139.329 | -20.52 | 0.1166 | 0.1180 | 0.23 | -2.393 | -2.421 | 16.246 | 16.441 | F | T | F | NaN | 2023-01-03 | F | F |
| 4 | 2__AANGE001 | 2__AANGE001 | Limejump Energy Limited | ANGEL | S | NaN | _A | Eastern GSP Group | DEFAULT__A | NaN | C | 0.002763 | 80.000 | -1.00 | 0.3955 | 0.3487 | 0.23 | -0.396 | -0.349 | 31.640 | 27.896 | F | T | F | NaN | 2023-01-03 | F | F |
| 5 | 2__AANGE002 | 2__AANGE002 | Limejump Energy Limited | ANGEL | S | AG-ALIM03 | _A | Eastern GSP Group | DEFAULT__A | NaN | C | 0.002763 | 50.000 | 0.00 | 0.3955 | 0.3487 | 0.23 | 0.000 | 0.000 | 11.500 | 11.500 | F | T | T | NaN | 2023-01-03 | F | F |
| 6 | 2__AANGE003 | 2__AANGE003 | Limejump Energy Limited | ANGEL | S | NaN | _A | Eastern GSP Group | DEFAULT__A | NaN | C | 0.002763 | 0.000 | 0.00 | 0.3955 | 0.3487 | 0.23 | 0.000 | 0.000 | 0.000 | 0.000 | F | T | F | NaN | 2023-01-03 | F | F |
| 7 | 2__AANGE004 | 2__AANGE004 | Limejump Energy Limited | ANGEL | S | NaN | _A | Eastern GSP Group | DEFAULT__A | NaN | C | 0.002763 | 0.000 | 0.00 | 0.3955 | 0.3487 | 0.23 | 0.000 | 0.000 | 0.000 | 0.000 | F | T | F | NaN | 2023-01-03 | F | F |
| 8 | 2__AARIZ000 | ARIZ_A | British Gas Trading Ltd | BRITGAS | G | NaN | _A | Eastern GSP Group | DEFAULT__A | NaN | C | 0.002763 | 0.000 | 0.00 | 0.3955 | 0.3487 | 0.23 | 0.000 | 0.000 | 0.000 | 0.000 | F | T | F | NaN | 2023-01-03 | F | F |
| 9 | 2__AARRU000 | 2__AARRU000 | British Gas Trading Ltd | BRITGAS | G | NaN | _A | Eastern GSP Group | DEFAULT__A | NaN | C | 0.002763 | 0.000 | -1.34 | 0.3955 | 0.3487 | 0.23 | -0.530 | -0.467 | 0.000 | 0.000 | F | T | F | NaN | 2023-01-03 | F | F |
| BM Unit ID | BMU Name | Party Name | Party ID | BMU Type | NGC BMU Name | GSP Group Id | GSP Group Name | Trading Unit Name | Prod/Cons Flag | Prod/Cons Status | TLF | GC | DC | WDCALF | NWDCALF | SECALF | WDBMCAIC | NWDBMCAIC | WDBMCAEC | NWDBMCAEC | Exempt Export Flag | Base TU Flag | FPN Flag | Interconnector Id | Effective From | Manual Credit Qualifying Flag | Credit Qualifying Status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5257 | V__LCEND005 | V__LCEND005 | Centrica Business Solutions UK | CENDEPUK | V | AG-CBS05L | _L | South Western | NaN | P | P | 0.012525 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | F | F | T | NaN | 2023-01-03 | F | NaN |
| 5258 | V__LFLEX001 | V__LFLEX001 | Flexitricity Limited | FLEXTRCY | V | AG-FLX00L | _L | South Western | NaN | C | C | 0.012525 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | F | F | T | NaN | 2023-01-03 | F | NaN |
| 5259 | V__MADEL001 | ADELA_SBMU_M | Adela Energy Ltd | ADELA | V | AG-ADL01M | _M | Yorkshire Electricity | NaN | P | P | -0.008370 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | F | F | T | NaN | 2023-01-03 | F | NaN |
| 5260 | V__MCEND002 | Allen Diesels | Centrica Business Solutions UK | CENDEPUK | V | CBSDIS03M | _M | Yorkshire Electricity | NaN | P | P | -0.008370 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | F | F | T | NaN | 2023-01-03 | F | NaN |
| 5261 | V__MEROV001 | V__MEROV001 | Erova Energy Limited | EROVAIRL | V | AG-ERV01M | _M | Yorkshire Electricity | NaN | C | C | -0.008370 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | F | F | T | NaN | 2023-01-03 | F | NaN |
| 5262 | V__MFLEX001 | V__MFLEX001 | Flexitricity Limited | FLEXTRCY | V | AG-FLX06M | _M | Yorkshire Electricity | NaN | C | C | -0.008370 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | F | F | T | NaN | 2023-01-03 | F | NaN |
| 5263 | V__MGBLO001 | V__MGBLO001 | GridBeyond Limited | ENDECO | V | AG-GBL04M | _M | Yorkshire Electricity | NaN | NaN | C | -0.008370 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | F | F | F | NaN | 2023-01-03 | F | NaN |
| 5264 | V__NFLEX001 | V__NFLEX001 | Flexitricity Limited | FLEXTRCY | V | AG-FLX02N | _N | SOUTH of SCOTLAND GSP | NaN | C | C | -0.004262 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | F | F | T | NaN | 2023-01-03 | F | NaN |
| 5265 | V__NFLEX002 | V__NFLEX002 | Flexitricity Limited | FLEXTRCY | V | AG-FLX07N | _N | SOUTH of SCOTLAND GSP | NaN | C | C | -0.004262 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | F | F | T | NaN | 2023-01-03 | F | NaN |
| 5266 | V__PFLEX001 | V__PFLEX001 | Flexitricity Limited | FLEXTRCY | V | AG-FLX01P | _P | NORTH of SCOTLAND GSP | NaN | C | C | -0.026124 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | F | F | T | NaN | 2023-01-03 | F | NaN |